package com.ugoodtech.mdcc.core.model.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StationsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StationsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }


        public Criteria andProductPositionListLike(List<String> productPositionList) {
            StringBuilder cri = new StringBuilder();
            for (String posi : productPositionList) {
                cri.append("product_position like '%").append(posi).append("%' or");
            }
            addCriterion(cri.substring(0, cri.lastIndexOf("or")));
            return (Criteria) this;
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreationTimeIsNull() {
            addCriterion("creation_time is null");
            return (Criteria) this;
        }

        public Criteria andCreationTimeIsNotNull() {
            addCriterion("creation_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreationTimeEqualTo(Date value) {
            addCriterion("creation_time =", value, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeNotEqualTo(Date value) {
            addCriterion("creation_time <>", value, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeGreaterThan(Date value) {
            addCriterion("creation_time >", value, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("creation_time >=", value, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeLessThan(Date value) {
            addCriterion("creation_time <", value, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeLessThanOrEqualTo(Date value) {
            addCriterion("creation_time <=", value, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeIn(List<Date> values) {
            addCriterion("creation_time in", values, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeNotIn(List<Date> values) {
            addCriterion("creation_time not in", values, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeBetween(Date value1, Date value2) {
            addCriterion("creation_time between", value1, value2, "creationTime");
            return (Criteria) this;
        }

        public Criteria andCreationTimeNotBetween(Date value1, Date value2) {
            addCriterion("creation_time not between", value1, value2, "creationTime");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andEnabledIsNull() {
            addCriterion("enabled is null");
            return (Criteria) this;
        }

        public Criteria andEnabledIsNotNull() {
            addCriterion("enabled is not null");
            return (Criteria) this;
        }

        public Criteria andEnabledEqualTo(Boolean value) {
            addCriterion("enabled =", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledNotEqualTo(Boolean value) {
            addCriterion("enabled <>", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledGreaterThan(Boolean value) {
            addCriterion("enabled >", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledGreaterThanOrEqualTo(Boolean value) {
            addCriterion("enabled >=", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledLessThan(Boolean value) {
            addCriterion("enabled <", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledLessThanOrEqualTo(Boolean value) {
            addCriterion("enabled <=", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledIn(List<Boolean> values) {
            addCriterion("enabled in", values, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledNotIn(List<Boolean> values) {
            addCriterion("enabled not in", values, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledBetween(Boolean value1, Boolean value2) {
            addCriterion("enabled between", value1, value2, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledNotBetween(Boolean value1, Boolean value2) {
            addCriterion("enabled not between", value1, value2, "enabled");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andCategoryIsNull() {
            addCriterion("category is null");
            return (Criteria) this;
        }

        public Criteria andCategoryIsNotNull() {
            addCriterion("category is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryEqualTo(String value) {
            addCriterion("category =", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotEqualTo(String value) {
            addCriterion("category <>", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryGreaterThan(String value) {
            addCriterion("category >", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryGreaterThanOrEqualTo(String value) {
            addCriterion("category >=", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLessThan(String value) {
            addCriterion("category <", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLessThanOrEqualTo(String value) {
            addCriterion("category <=", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryLike(String value) {
            addCriterion("category like", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotLike(String value) {
            addCriterion("category not like", value, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryIn(List<String> values) {
            addCriterion("category in", values, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotIn(List<String> values) {
            addCriterion("category not in", values, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryBetween(String value1, String value2) {
            addCriterion("category between", value1, value2, "category");
            return (Criteria) this;
        }

        public Criteria andCategoryNotBetween(String value1, String value2) {
            addCriterion("category not between", value1, value2, "category");
            return (Criteria) this;
        }

        public Criteria andCheckStationIsNull() {
            addCriterion("check_station is null");
            return (Criteria) this;
        }

        public Criteria andCheckStationIsNotNull() {
            addCriterion("check_station is not null");
            return (Criteria) this;
        }

        public Criteria andCheckStationEqualTo(Boolean value) {
            addCriterion("check_station =", value, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationNotEqualTo(Boolean value) {
            addCriterion("check_station <>", value, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationGreaterThan(Boolean value) {
            addCriterion("check_station >", value, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationGreaterThanOrEqualTo(Boolean value) {
            addCriterion("check_station >=", value, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationLessThan(Boolean value) {
            addCriterion("check_station <", value, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationLessThanOrEqualTo(Boolean value) {
            addCriterion("check_station <=", value, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationIn(List<Boolean> values) {
            addCriterion("check_station in", values, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationNotIn(List<Boolean> values) {
            addCriterion("check_station not in", values, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationBetween(Boolean value1, Boolean value2) {
            addCriterion("check_station between", value1, value2, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCheckStationNotBetween(Boolean value1, Boolean value2) {
            addCriterion("check_station not between", value1, value2, "checkStation");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andColorreportidIsNull() {
            addCriterion("colorReportId is null");
            return (Criteria) this;
        }

        public Criteria andColorreportidIsNotNull() {
            addCriterion("colorReportId is not null");
            return (Criteria) this;
        }

        public Criteria andColorreportidEqualTo(Long value) {
            addCriterion("colorReportId =", value, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidNotEqualTo(Long value) {
            addCriterion("colorReportId <>", value, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidGreaterThan(Long value) {
            addCriterion("colorReportId >", value, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidGreaterThanOrEqualTo(Long value) {
            addCriterion("colorReportId >=", value, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidLessThan(Long value) {
            addCriterion("colorReportId <", value, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidLessThanOrEqualTo(Long value) {
            addCriterion("colorReportId <=", value, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidIn(List<Long> values) {
            addCriterion("colorReportId in", values, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidNotIn(List<Long> values) {
            addCriterion("colorReportId not in", values, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidBetween(Long value1, Long value2) {
            addCriterion("colorReportId between", value1, value2, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andColorreportidNotBetween(Long value1, Long value2) {
            addCriterion("colorReportId not between", value1, value2, "colorreportid");
            return (Criteria) this;
        }

        public Criteria andContactIsNull() {
            addCriterion("contact is null");
            return (Criteria) this;
        }

        public Criteria andContactIsNotNull() {
            addCriterion("contact is not null");
            return (Criteria) this;
        }

        public Criteria andContactEqualTo(String value) {
            addCriterion("contact =", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotEqualTo(String value) {
            addCriterion("contact <>", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactGreaterThan(String value) {
            addCriterion("contact >", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactGreaterThanOrEqualTo(String value) {
            addCriterion("contact >=", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactLessThan(String value) {
            addCriterion("contact <", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactLessThanOrEqualTo(String value) {
            addCriterion("contact <=", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactLike(String value) {
            addCriterion("contact like", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotLike(String value) {
            addCriterion("contact not like", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactIn(List<String> values) {
            addCriterion("contact in", values, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotIn(List<String> values) {
            addCriterion("contact not in", values, "contact");
            return (Criteria) this;
        }

        public Criteria andContactBetween(String value1, String value2) {
            addCriterion("contact between", value1, value2, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotBetween(String value1, String value2) {
            addCriterion("contact not between", value1, value2, "contact");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNull() {
            addCriterion("district is null");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNotNull() {
            addCriterion("district is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictEqualTo(String value) {
            addCriterion("district =", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotEqualTo(String value) {
            addCriterion("district <>", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThan(String value) {
            addCriterion("district >", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThanOrEqualTo(String value) {
            addCriterion("district >=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThan(String value) {
            addCriterion("district <", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThanOrEqualTo(String value) {
            addCriterion("district <=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLike(String value) {
            addCriterion("district like", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotLike(String value) {
            addCriterion("district not like", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictIn(List<String> values) {
            addCriterion("district in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotIn(List<String> values) {
            addCriterion("district not in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictBetween(String value1, String value2) {
            addCriterion("district between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotBetween(String value1, String value2) {
            addCriterion("district not between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andStationNumIsNull() {
            addCriterion("station_num is null");
            return (Criteria) this;
        }

        public Criteria andStationNumIsNotNull() {
            addCriterion("station_num is not null");
            return (Criteria) this;
        }

        public Criteria andStationNumEqualTo(String value) {
            addCriterion("station_num =", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumNotEqualTo(String value) {
            addCriterion("station_num <>", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumGreaterThan(String value) {
            addCriterion("station_num >", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumGreaterThanOrEqualTo(String value) {
            addCriterion("station_num >=", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumLessThan(String value) {
            addCriterion("station_num <", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumLessThanOrEqualTo(String value) {
            addCriterion("station_num <=", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumLike(String value) {
            addCriterion("station_num like", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumNotLike(String value) {
            addCriterion("station_num not like", value, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumIn(List<String> values) {
            addCriterion("station_num in", values, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumNotIn(List<String> values) {
            addCriterion("station_num not in", values, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumBetween(String value1, String value2) {
            addCriterion("station_num between", value1, value2, "stationNum");
            return (Criteria) this;
        }

        public Criteria andStationNumNotBetween(String value1, String value2) {
            addCriterion("station_num not between", value1, value2, "stationNum");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Long value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Long value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Long value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Long value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Long value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Long> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Long> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Long value1, Long value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Long value1, Long value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andCustomerStatIsNull() {
            addCriterion("customer_stat is null");
            return (Criteria) this;
        }

        public Criteria andCustomerStatIsNotNull() {
            addCriterion("customer_stat is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerStatEqualTo(Long value) {
            addCriterion("customer_stat =", value, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatNotEqualTo(Long value) {
            addCriterion("customer_stat <>", value, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatGreaterThan(Long value) {
            addCriterion("customer_stat >", value, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatGreaterThanOrEqualTo(Long value) {
            addCriterion("customer_stat >=", value, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatLessThan(Long value) {
            addCriterion("customer_stat <", value, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatLessThanOrEqualTo(Long value) {
            addCriterion("customer_stat <=", value, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatIn(List<Long> values) {
            addCriterion("customer_stat in", values, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatNotIn(List<Long> values) {
            addCriterion("customer_stat not in", values, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatBetween(Long value1, Long value2) {
            addCriterion("customer_stat between", value1, value2, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerStatNotBetween(Long value1, Long value2) {
            addCriterion("customer_stat not between", value1, value2, "customerStat");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIsNull() {
            addCriterion("customer_type is null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIsNotNull() {
            addCriterion("customer_type is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeEqualTo(Long value) {
            addCriterion("customer_type =", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotEqualTo(Long value) {
            addCriterion("customer_type <>", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeGreaterThan(Long value) {
            addCriterion("customer_type >", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeGreaterThanOrEqualTo(Long value) {
            addCriterion("customer_type >=", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLessThan(Long value) {
            addCriterion("customer_type <", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeLessThanOrEqualTo(Long value) {
            addCriterion("customer_type <=", value, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeIn(List<Long> values) {
            addCriterion("customer_type in", values, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotIn(List<Long> values) {
            addCriterion("customer_type not in", values, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeBetween(Long value1, Long value2) {
            addCriterion("customer_type between", value1, value2, "customerType");
            return (Criteria) this;
        }

        public Criteria andCustomerTypeNotBetween(Long value1, Long value2) {
            addCriterion("customer_type not between", value1, value2, "customerType");
            return (Criteria) this;
        }

        public Criteria andProductPositionIsNull() {
            addCriterion("product_position is null");
            return (Criteria) this;
        }

        public Criteria andProductPositionIsNotNull() {
            addCriterion("product_position is not null");
            return (Criteria) this;
        }

        public Criteria andProductPositionEqualTo(String value) {
            addCriterion("product_position =", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionNotEqualTo(String value) {
            addCriterion("product_position <>", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionGreaterThan(String value) {
            addCriterion("product_position >", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionGreaterThanOrEqualTo(String value) {
            addCriterion("product_position >=", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionLessThan(String value) {
            addCriterion("product_position <", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionLessThanOrEqualTo(String value) {
            addCriterion("product_position <=", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionLike(String value) {
            addCriterion("product_position like", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionNotLike(String value) {
            addCriterion("product_position not like", value, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionIn(List<String> values) {
            addCriterion("product_position in", values, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionNotIn(List<String> values) {
            addCriterion("product_position not in", values, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionBetween(String value1, String value2) {
            addCriterion("product_position between", value1, value2, "productPosition");
            return (Criteria) this;
        }

        public Criteria andProductPositionNotBetween(String value1, String value2) {
            addCriterion("product_position not between", value1, value2, "productPosition");
            return (Criteria) this;
        }

        public Criteria andPaintBrandIsNull() {
            addCriterion("paint_brand is null");
            return (Criteria) this;
        }

        public Criteria andPaintBrandIsNotNull() {
            addCriterion("paint_brand is not null");
            return (Criteria) this;
        }

        public Criteria andPaintBrandEqualTo(String value) {
            addCriterion("paint_brand =", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandNotEqualTo(String value) {
            addCriterion("paint_brand <>", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandGreaterThan(String value) {
            addCriterion("paint_brand >", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandGreaterThanOrEqualTo(String value) {
            addCriterion("paint_brand >=", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandLessThan(String value) {
            addCriterion("paint_brand <", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandLessThanOrEqualTo(String value) {
            addCriterion("paint_brand <=", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandLike(String value) {
            addCriterion("paint_brand like", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandNotLike(String value) {
            addCriterion("paint_brand not like", value, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandIn(List<String> values) {
            addCriterion("paint_brand in", values, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandNotIn(List<String> values) {
            addCriterion("paint_brand not in", values, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandBetween(String value1, String value2) {
            addCriterion("paint_brand between", value1, value2, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andPaintBrandNotBetween(String value1, String value2) {
            addCriterion("paint_brand not between", value1, value2, "paintBrand");
            return (Criteria) this;
        }

        public Criteria andIsPaintIsNull() {
            addCriterion("is_paint is null");
            return (Criteria) this;
        }

        public Criteria andIsPaintIsNotNull() {
            addCriterion("is_paint is not null");
            return (Criteria) this;
        }

        public Criteria andIsPaintEqualTo(Integer value) {
            addCriterion("is_paint =", value, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintNotEqualTo(Integer value) {
            addCriterion("is_paint <>", value, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintGreaterThan(Integer value) {
            addCriterion("is_paint >", value, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_paint >=", value, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintLessThan(Integer value) {
            addCriterion("is_paint <", value, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintLessThanOrEqualTo(Integer value) {
            addCriterion("is_paint <=", value, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintIn(List<Integer> values) {
            addCriterion("is_paint in", values, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintNotIn(List<Integer> values) {
            addCriterion("is_paint not in", values, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintBetween(Integer value1, Integer value2) {
            addCriterion("is_paint between", value1, value2, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsPaintNotBetween(Integer value1, Integer value2) {
            addCriterion("is_paint not between", value1, value2, "isPaint");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandIsNull() {
            addCriterion("is_other_brand is null");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandIsNotNull() {
            addCriterion("is_other_brand is not null");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandEqualTo(Boolean value) {
            addCriterion("is_other_brand =", value, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandNotEqualTo(Boolean value) {
            addCriterion("is_other_brand <>", value, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandGreaterThan(Boolean value) {
            addCriterion("is_other_brand >", value, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandGreaterThanOrEqualTo(Boolean value) {
            addCriterion("is_other_brand >=", value, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandLessThan(Boolean value) {
            addCriterion("is_other_brand <", value, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandLessThanOrEqualTo(Boolean value) {
            addCriterion("is_other_brand <=", value, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandIn(List<Boolean> values) {
            addCriterion("is_other_brand in", values, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandNotIn(List<Boolean> values) {
            addCriterion("is_other_brand not in", values, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandBetween(Boolean value1, Boolean value2) {
            addCriterion("is_other_brand between", value1, value2, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andIsOtherBrandNotBetween(Boolean value1, Boolean value2) {
            addCriterion("is_other_brand not between", value1, value2, "isOtherBrand");
            return (Criteria) this;
        }

        public Criteria andReportFinishedIsNull() {
            addCriterion("report_finished is null");
            return (Criteria) this;
        }

        public Criteria andReportFinishedIsNotNull() {
            addCriterion("report_finished is not null");
            return (Criteria) this;
        }

        public Criteria andReportFinishedEqualTo(Integer value) {
            addCriterion("report_finished =", value, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedNotEqualTo(Integer value) {
            addCriterion("report_finished <>", value, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedGreaterThan(Integer value) {
            addCriterion("report_finished >", value, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedGreaterThanOrEqualTo(Integer value) {
            addCriterion("report_finished >=", value, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedLessThan(Integer value) {
            addCriterion("report_finished <", value, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedLessThanOrEqualTo(Integer value) {
            addCriterion("report_finished <=", value, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedIn(List<Integer> values) {
            addCriterion("report_finished in", values, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedNotIn(List<Integer> values) {
            addCriterion("report_finished not in", values, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedBetween(Integer value1, Integer value2) {
            addCriterion("report_finished between", value1, value2, "reportFinished");
            return (Criteria) this;
        }

        public Criteria andReportFinishedNotBetween(Integer value1, Integer value2) {
            addCriterion("report_finished not between", value1, value2, "reportFinished");
            return (Criteria) this;
        }

    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}